Life Expectancy at Birth

Download data

Data comes from WTN. Separate CSVs at the census tract geography are available (manual download) for 5y time spans at 1y increments, starting in 2000, until 2020.

The four possible WTN data sets that could be used without overlapping years include 1,465 records each. This closely matches the number of records in the 2010 census tract shapefile published by the US Census Bureau, Geography Division (1,458; in comparison to the 1,784 tracts in the 2020 shapefile).

Although there are 4 possible data sets (2001-2005, 2006-2010, 2011-2015, 2016-2020), we will be using the three more recent data sets in the following visuals.

Access other data

The other data pieces include:

  • equity quintile data (low, low medium, etc.) at the tract-level for each equity focus group for the years that correspond to the life expectancy data (2010, 2015, 2020)
  • 2010-2020 crosswalk file (for the 2016-2020 life expectancy data set)
  • tract-level population data (to weight life expectancy for 2010, 2015, 2020)
  • 2020 tract spatial file (for mapping most recent data)

Using 2010 and 2020 equity quintiles

Merge/Clean

The 2010 and 2015 equity tracts are in 2010 geographies and include ~770 census tracts, each of which are assigned one of the 5 quintile categories for each of the 6 equity demographic groups. The 2010, 2015, an 2020 life expectancy data are available from WTN in 2010 geographies, so the 2020-year data will need to be translated to 2020 geographies to be able to use the 2020 population information.

Transform

The data sets need to be cleaned and pivoted to a longer table so that there is only one field for the 6 different equity categories, instead of one field for each.

Calculate by region

The life expectancy values are available at the census tract level, but we want to calculate the regional average, using the census bureau’s tract-level population estimates (2010, 2015, 2020).

Calculate by equity quintile

The life expectancy values are available at the census tract level but we want to calculate the weighted values by the 6 equity/5 quintile groups, using the census bureau’s tract-level population estimates (2010, 2015, 2020).

The regional population in 2010:
The regional population in 2015:
The regional population in 2020:

Combine years

Visuals

1. Map of most recent data

2. Facet chart of most recent

3. Time series

Line chart

All quintiles
By equity group

The y-axis scale is consistent for all equity group facets, but it shifts by county.

By county

The y-axis scale is consistent for all county facets, but it shifts by equity group.


High/low quintiles
By equity group

The y-axis scale is consistent for all equity group facets, but it shifts by county.

By county

The y-axis scale is consistent for all county facets, but it shifts by equity group.


First/last years
By equity group

The y-axis scale is consistent for all equity group facets, but it shifts by county.

By county

The y-axis scale is consistent for all county facets, but it shifts by equity group.


Cleveland dot plot

By county and quintile


King: There are 5 charts for the different equity quintiles (high, medium high, medium, low medium, low).



Kitsap: There are 5 charts for the different equity quintiles (high, medium high, medium, low medium, low).



Pierce: There are 5 charts for the different equity quintiles (high, medium high, medium, low medium, low).



Snowhomish: There are 5 charts for the different equity quintiles (high, medium high, medium, low medium, low).


By county and equity group


King: There are 6 charts for the different equity groups (POC, low-income, etc.)



Kitsap: There are 6 charts for the different equity groups (POC, low-income, etc.)



Pierce: There are 6 charts for the different equity groups (POC, low-income, etc.)



Snohomish: There are 6 charts for the different equity groups (POC, low-income, etc.)




Using 2020 population and 2020 equity quintiles

Merge

Transform

Calculate by 2020 equity quintiles